Cameron Williamson
Visitsite: Itech-themesSelf-reflection requires courage and patience. Teaching students to be self- them a skill that will help them throughout their lives.
Microsoft Advanced Excel
XL Technologies is a company specializing in corporate training for Advanced Microsoft Excel and Microsoft Office Professional. Our team comprises skilled trainers with over five years of experience in corporate training. Our tailored training program is designed to elevate your abilities in creating accurate and efficient reports through the utilization of intricate formulas, charts, and graphs. This course will significantly enhance your productivity and contribute to your professional distinction.
The following are some of the key areas wherein the complete knowledge of excel is essential to secure a job. It works as a GREEN CARD for your easy entry apart from being a professional tool.
6 Module
17 Live class
53 Assignment
6 Test Project Lecture 1.1 Introduction Lecture 1.2 Accounting Principles, Concepts and Conventions Lecture 1.3 Golden Rules of Accounting Lecture 1.4 Types of Current Assets & Liabilities Lecture 1.5 Five Important heads of Accounts Lecture 1.6 Double Entry System of Book-keeping. Lecture 1.7 Rules of Accounting & Recording the Transactions. Lecture 1.8 Financial Statements-Trading Account, Profit & Loss Account, Trial Balance &
Balance Sheet. Lecture 1.1 Setting up of Company in Tally. ERP 9-Create a Company, select a Company,
Alter a Company, Shut a Company. Lecture 1.2 F11: Company Features-F1: Accounting Features, F2: Inventory Features, F3:
Statutory & Taxation Python Lecture 1.3 F12: Configuration – General Configuration, Numeric Symbols, Accts/Inventory
Info, Voucher Entry Configuration, Invoice/Orders Entry Configuration, Payroll
Configuration. Lecture 1.4 Creating Group-Single & Multiple Group, Displaying Group, Alter Group.
Lecture 1.5 Creating Ledger – Single & Multiple Ledger, Displaying Ledger, Altering
Ledger.Stock Groups-Create Single & Multiple Stock Group, Displaying & Altering Stock
Groups Lecture 1.6 Stock Categories-Create Single& Multiple Stock Group, Displaying& Altering
Stock Groups Lecture 1.7 Units of Measure – Simple units, Compound units, Creating Simple Units,
Creating Compound Units, Displaying Units of Measure, Deleting Units of Measure Lecture 1.8 Go downs- Creating Single Go down, Creating Multiple Go down, Displaying Go
down, Altering Go downs Lecture 1.9 Stock Items – Creating Single Stock Item, Creating Multiple Stock Items,
Displaying Stock Items, Altering Stock Items. Lecture 1.10 Voucher Types-Predefined Vouchers in Tally-ERP, Creating Voucher Type,
Displaying Voucher Type, Altering Voucher Types Lecture 1.11 Accounting Vouchers-Contra Voucher(F4),Payment Voucher(F5),Receipt
Voucher(F6),Journal Voucher(F7),Purchase Voucher(F9),Sales Voucher(F8)Credit Note
Voucher(CTRL+F8),Debit Note Voucher(CTRL+F9) Lecture 1.1 Bill – wise Details – Activating Bill wise Details, New Reference, View
Outstanding Statement, Against Reference Lecture 1.2 Cost Centers and Cost Categories-Creating Cost Centers, Activating Cost
Category and Cost Centre Lecture 1.3 Bank Reconciliation Statement, Deposit Slip, Payment Advice Lecture 1.4 Scenario Management – Reversing Journals, Memorandum Vouchers, Activating
Scenarios, Creating a Scenario, Altering a Scenario Lecture 1.1 Basic Concepts in VAT Lecture 1.2 Configuring VAT in Tally. ERP 9-Company setup, Enabling Value Added in
Tax(VAT),VAT Classifications Lecture 1.3 Creating Masters-Creating Purchase Ledger, Creating Sales Ledger, Creating
Input VAT Ledger, Creating Party Ledgers, Creating Stock Items. Lecture 1.4 VAT Reports-VAT Computation, VAT Returns, e-VAT Returns, VAT Commodity, VAT
Register. Lecture 1.5 Basics of Central Sales Tax(CST) Lecture 1.6 Enabling CST in Tally.ERP9-Company Setup, Creating Masters. Lecture 1.7 Recording Interstate Transactions in Tally.ERP9-Inter-state Purchases,
Inter-state Sales against C Forms, Exports against H Form Lecture 1.8 Basic Concepts of TDS Lecture 1.9 Configuring TDS in Tally. ERP 9-Enabling TDS in Tally. ERP 9. Lecture 1.10 TDS Reports-Computation, Challan Reconciliation, Return, e-TDS Returns.
Lecture 1.11 Basics of Service Tax Lecture 1.12 Configuring Tally. ERP 9 for Service Tax-Salient Features of Service Tax
Compliant Tally. ERP 9, Company Setup, Enabling Service Tax. Lecture 1.13 5 Important Head of Income Tax (Income from House Property, Income from
Salary, Profit & Gains from Business or Profession, Capital Gain, Income from Other
Sources) Lecture 1.14 Method of Income Tax Return Filling Lecture 1.15 E-filling of Return using excel utility Lecture 1.16 Payment of Tax Lecture 1.1 Introduction the Payroll System Lecture 1.2 Annual Reporting & Task Lecture 1.1 What is GST (Goods and Services Tax) Lecture 1.2 Taxes under GST Lecture 1.3 Central GST(CGST) Lecture 1.4 State GST(SGST) Lecture 1.5 HSN Codes for GST in India Lecture 1.6 HSN in GST Lecture 1.7 GST Registration Lecture 1.8 Who is an Input service distributor (ISD) under GST? Lecture 1.9 What is Composition Scheme under GST? Lecture 1.10 Conditions for Opting for Composition Scheme under GST Lecture 1.11 Rate of Composition Levy in GST Lecture 1.12 Course Revision & Doubt Clearing Session
Self-reflection requires courage and patience. Teaching students to be self- them a skill that will help them throughout their lives.
Course Pricing
$65.00$90.00
Course Features
4.5 (120)
Jerome Bell
4.5 (120)
Jerome Bell
4.5 (120)
Jerome Bell
4.5 (120)
Jerome Bell
